<%@ page contentType="text/html; charset=utf-8" %>
<%@ page import="java.util.Date"%>
<jsp:useBean id="connection" scope="page" class="com.wy.JDBConnection"/>
<html>
<head>
<title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

placard_show_config page
</title>
</head>
<%!
String sql;
Date date=new Date();
%>
<body bgcolor="#ffffff">
<%
request.setCharacterEncoding("utf-8");
String trademark=request.getParameter("trademark");
String brand=request.getParameter("brand");
String style=request.getParameter("style");
String carload=request.getParameter("carload");
String usedtime=request.getParameter("usedtime");
String drivername=request.getParameter("drivername");
String drivertime=request.getParameter("drivertime");
String licencenumber=request.getParameter("licencenumber");
String licencestyle=request.getParameter("licencestyle");
String transpotstylle=request.getParameter("transpotstylle");
String linkman=request.getParameter("linkman");
String linkphone=request.getParameter("linkphone");
String remark=request.getParameter("remark");
String username=request.getParameter("username");



java.sql.Date datatime=new java.sql.Date(date.getYear(),date.getMonth(),date.getDate());
sql="insert into tb_carmessage(trademark,brand,style,carload,usedtime,drivername,drivertime,"
+"licencenumber,licencestyle,transpotstylle,linkman,linkphone,username,remark) "+
"values('"+trademark+"','"+brand+"','"+style+"','"+carload+"','"+usedtime+"','"+drivername+"'"+
",'"+drivertime+"','"+licencenumber+"','"+licencestyle+"'"+
",'"+transpotstylle+"','"+linkman+"','"+linkphone+"','"+username+"','"+remark+"')";
boolean bb=connection.insert(sql);
if(bb)
{%>
<script language="javascript">
alert("您输入的车辆信息已经存储完成！！！");
</script>
<%
response.sendRedirect("car_select.jsp");
}else
{
%>
<script language="javascript">
alert("您输入的车辆信息存储失败！！！");
history.back();
</script>
<%
}
%>
</body>
</html>

